2025-04-02 16:49:27,555 [ 340456 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:53, check_args_and_update_paths) 2025-04-02 16:49:27,556 [ 340456 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:97, check_args_and_update_paths) 2025-04-02 16:49:27,556 [ 340456 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:108, check_args_and_update_paths) 2025-04-02 16:49:27,556 [ 340456 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:110, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_86ijid --privileged --dns-search='.' --memory=30709035008 --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=5dc43a6382f0 -e DOCKER_BASE_TAG=6712d5cc610d -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=caad4729259e -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e CLICKHOUSE_USE_OLD_ANALYZER=1 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_storage_rabbitmq/test.py::test_rabbitmq_insert_headers_exchange test_storage_rabbitmq/test.py::test_rabbitmq_issue_30691 test_storage_rabbitmq/test.py::test_rabbitmq_json_without_delimiter test_storage_rabbitmq/test.py::test_rabbitmq_macros test_storage_rabbitmq/test.py::test_rabbitmq_many_consumers_to_each_queue test_storage_rabbitmq/test.py::test_rabbitmq_many_inserts test_storage_rabbitmq/test.py::test_rabbitmq_many_materialized_views test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view_with_subquery test_storage_rabbitmq/test.py::test_rabbitmq_msgpack test_storage_rabbitmq/test.py::test_rabbitmq_multiple_bindings test_storage_rabbitmq/test.py::test_rabbitmq_mv_combo test_storage_rabbitmq/test.py::test_rabbitmq_nack_failed_insert test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_1 test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_2 test_storage_rabbitmq/test.py::test_rabbitmq_overloaded_insert test_storage_rabbitmq/test.py::test_rabbitmq_predefined_configuration test_storage_rabbitmq/test.py::test_rabbitmq_produce_consume_avro test_storage_rabbitmq/test.py::test_rabbitmq_queue_consume test_storage_rabbitmq/test.py::test_rabbitmq_queue_settings test_storage_rabbitmq/test.py::test_rabbitmq_random_detach test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 'test_storage_rabbitmq/test.py::test_rabbitmq_select[0]' 'test_storage_rabbitmq/test.py::test_rabbitmq_select[1]' test_storage_rabbitmq/test.py::test_rabbitmq_select_empty test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter test_storage_rabbitmq/test.py::test_rabbitmq_vhost test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view test_storage_rabbitmq/test.py::test_row_based_formats test_system_queries/test.py::test_DROP_DNS_CACHE test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY test_system_queries/test.py::test_system_flush_logs test_table_function_redis/test.py::test_create_table test_table_function_redis/test.py::test_data_type test_table_function_redis/test.py::test_simple_select test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_with_interserver_listen_host test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_without_interserver_listen_host 'test_throttling/test.py::test_backup_throttling[no_local_throttling]' 'test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling]' 'test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[server_local_throttling]' 'test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling]' 'test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[user_local_throttling]' 'test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling]' 'test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling]' test_throttling/test.py::test_backup_throttling_override test_throttling/test.py::test_max_merges_bandwidth_for_server test_throttling/test.py::test_max_mutations_bandwidth_for_server 'test_throttling/test.py::test_read_throttling[no_local_throttling]' 'test_throttling/test.py::test_read_throttling[no_remote_throttling]' 'test_throttling/test.py::test_read_throttling[server_local_throttling]' 'test_throttling/test.py::test_read_throttling[server_remote_throttling]' 'test_throttling/test.py::test_read_throttling[user_local_throttling]' 'test_throttling/test.py::test_read_throttling[user_remote_throttling]' 'test_throttling/test.py::test_write_throttling[local_server_throttling]' 'test_throttling/test.py::test_write_throttling[local_user_throttling]' 'test_throttling/test.py::test_write_throttling[no_local_throttling]' 'test_throttling/test.py::test_write_throttling[no_remote_throttling]' 'test_throttling/test.py::test_write_throttling[server_remote_throttling]' 'test_throttling/test.py::test_write_throttling[user_remote_throttling]' -vvv" altinityinfra/integration-tests-runner:cd6390247eca '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: random-0.2, timeout-2.2.0, repeat-0.9.3, order-1.0.0, reportlog-0.4.0, xdist-3.5.0 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [70 items] scheduling tests via LoadFileScheduling test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_with_interserver_listen_host test_table_function_redis/test.py::test_create_table test_system_queries/test.py::test_DROP_DNS_CACHE test_storage_rabbitmq/test.py::test_rabbitmq_insert_headers_exchange test_throttling/test.py::test_backup_throttling[no_local_throttling] [gw4] [ 1%] PASSED test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_with_interserver_listen_host test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_without_interserver_listen_host [gw4] [ 2%] PASSED test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_without_interserver_listen_host [gw2] [ 4%] PASSED test_throttling/test.py::test_backup_throttling[no_local_throttling] [gw1] [ 5%] PASSED test_system_queries/test.py::test_DROP_DNS_CACHE test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS [gw1] [ 7%] PASSED test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling] [gw2] [ 8%] PASSED test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling] [gw1] [ 10%] PASSED test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY test_system_queries/test.py::test_system_flush_logs [gw0] [ 11%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_insert_headers_exchange [gw3] [ 12%] PASSED test_table_function_redis/test.py::test_create_table test_table_function_redis/test.py::test_data_type test_storage_rabbitmq/test.py::test_rabbitmq_issue_30691 [gw3] [ 14%] PASSED test_table_function_redis/test.py::test_data_type test_table_function_redis/test.py::test_simple_select [gw3] [ 15%] PASSED test_table_function_redis/test.py::test_simple_select [gw0] [ 17%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_issue_30691 test_storage_rabbitmq/test.py::test_rabbitmq_json_without_delimiter test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling] [gw2] [ 18%] PASSED test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling] [gw0] [ 20%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_json_without_delimiter test_storage_rabbitmq/test.py::test_rabbitmq_macros [gw1] [ 21%] PASSED test_system_queries/test.py::test_system_flush_logs [gw0] [ 22%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_macros test_storage_rabbitmq/test.py::test_rabbitmq_many_consumers_to_each_queue test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling] [gw2] [ 24%] PASSED test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling] test_throttling/test.py::test_backup_throttling[server_local_throttling] [gw2] [ 25%] PASSED test_throttling/test.py::test_backup_throttling[server_local_throttling] test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling] [gw2] [ 27%] PASSED test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling] test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling] [gw0] [ 28%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_many_consumers_to_each_queue test_storage_rabbitmq/test.py::test_rabbitmq_many_inserts [gw2] [ 30%] PASSED test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling] test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling] [gw2] [ 31%] PASSED test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling] test_throttling/test.py::test_backup_throttling[user_local_throttling] [gw0] [ 32%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_many_inserts test_storage_rabbitmq/test.py::test_rabbitmq_many_materialized_views [gw0] [ 34%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_many_materialized_views test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view [gw0] [ 35%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view_with_subquery [gw2] [ 37%] PASSED test_throttling/test.py::test_backup_throttling[user_local_throttling] [gw0] [ 38%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view_with_subquery test_storage_rabbitmq/test.py::test_rabbitmq_msgpack [gw0] [ 40%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_msgpack test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling] test_storage_rabbitmq/test.py::test_rabbitmq_multiple_bindings [gw2] [ 41%] PASSED test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling] test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling] [gw2] [ 42%] PASSED test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling] test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling] [gw2] [ 44%] PASSED test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling] [gw0] [ 45%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_multiple_bindings test_storage_rabbitmq/test.py::test_rabbitmq_mv_combo test_throttling/test.py::test_backup_throttling_override [gw2] [ 47%] PASSED test_throttling/test.py::test_backup_throttling_override test_throttling/test.py::test_max_merges_bandwidth_for_server [gw2] [ 48%] PASSED test_throttling/test.py::test_max_merges_bandwidth_for_server test_throttling/test.py::test_max_mutations_bandwidth_for_server [gw2] [ 50%] PASSED test_throttling/test.py::test_max_mutations_bandwidth_for_server test_throttling/test.py::test_read_throttling[no_local_throttling] [gw2] [ 51%] PASSED test_throttling/test.py::test_read_throttling[no_local_throttling] test_throttling/test.py::test_read_throttling[no_remote_throttling] [gw2] [ 52%] PASSED test_throttling/test.py::test_read_throttling[no_remote_throttling] test_throttling/test.py::test_read_throttling[server_local_throttling] [gw2] [ 54%] PASSED test_throttling/test.py::test_read_throttling[server_local_throttling] [gw0] [ 55%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_mv_combo test_storage_rabbitmq/test.py::test_rabbitmq_nack_failed_insert test_throttling/test.py::test_read_throttling[server_remote_throttling] [gw0] [ 57%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_nack_failed_insert test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_1 [gw0] [ 58%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_1 test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_2 [gw2] [ 60%] PASSED test_throttling/test.py::test_read_throttling[server_remote_throttling] [gw0] [ 61%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_2 test_throttling/test.py::test_read_throttling[user_local_throttling] test_storage_rabbitmq/test.py::test_rabbitmq_overloaded_insert [gw2] [ 62%] PASSED test_throttling/test.py::test_read_throttling[user_local_throttling] test_throttling/test.py::test_read_throttling[user_remote_throttling] [gw0] [ 64%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_overloaded_insert test_storage_rabbitmq/test.py::test_rabbitmq_predefined_configuration [gw2] [ 65%] PASSED test_throttling/test.py::test_read_throttling[user_remote_throttling] [gw0] [ 67%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_predefined_configuration test_storage_rabbitmq/test.py::test_rabbitmq_produce_consume_avro test_throttling/test.py::test_write_throttling[local_server_throttling] [gw0] [ 68%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_produce_consume_avro test_storage_rabbitmq/test.py::test_rabbitmq_queue_consume [gw2] [ 70%] PASSED test_throttling/test.py::test_write_throttling[local_server_throttling] [gw0] [ 71%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_queue_consume test_storage_rabbitmq/test.py::test_rabbitmq_queue_settings test_throttling/test.py::test_write_throttling[local_user_throttling] [gw0] [ 72%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_queue_settings test_storage_rabbitmq/test.py::test_rabbitmq_random_detach [gw2] [ 74%] PASSED test_throttling/test.py::test_write_throttling[local_user_throttling] test_throttling/test.py::test_write_throttling[no_local_throttling] [gw2] [ 75%] PASSED test_throttling/test.py::test_write_throttling[no_local_throttling] test_throttling/test.py::test_write_throttling[no_remote_throttling] [gw2] [ 77%] PASSED test_throttling/test.py::test_write_throttling[no_remote_throttling] test_throttling/test.py::test_write_throttling[server_remote_throttling] [gw2] [ 78%] PASSED test_throttling/test.py::test_write_throttling[server_remote_throttling] test_throttling/test.py::test_write_throttling[user_remote_throttling] [gw2] [ 80%] PASSED test_throttling/test.py::test_write_throttling[user_remote_throttling] [gw0] [ 81%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_random_detach test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages [gw0] [ 82%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 [gw0] [ 84%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 [gw0] [ 85%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 test_storage_rabbitmq/test.py::test_rabbitmq_select[0] [gw0] [ 87%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select[0] test_storage_rabbitmq/test.py::test_rabbitmq_select[1] [gw0] [ 88%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select[1] test_storage_rabbitmq/test.py::test_rabbitmq_select_empty [gw0] [ 90%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select_empty test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish [gw0] [ 91%] FAILED test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange [gw0] [ 92%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter [gw0] [ 94%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter test_storage_rabbitmq/test.py::test_rabbitmq_vhost [gw0] [ 95%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_vhost test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns [gw0] [ 97%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view [gw0] [ 98%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view test_storage_rabbitmq/test.py::test_row_based_formats [gw0] [100%] PASSED test_storage_rabbitmq/test.py::test_row_based_formats =================================== FAILURES =================================== ________________ test_rabbitmq_sharding_between_queues_publish _________________ [gw0] linux -- Python 3.10.12 /usr/bin/python3 rabbitmq_cluster = def test_rabbitmq_sharding_between_queues_publish(rabbitmq_cluster): NUM_CONSUMERS = 10 NUM_QUEUES = 10 logging.getLogger("pika").propagate = False instance.query( """ CREATE TABLE test.rabbitmq (key UInt64, value UInt64) ENGINE = RabbitMQ SETTINGS rabbitmq_host_port = 'rabbitmq1:5672', rabbitmq_exchange_name = 'test_sharding', rabbitmq_num_queues = 5, rabbitmq_num_consumers = 10, rabbitmq_max_block_size = 100, rabbitmq_flush_interval_ms=500, rabbitmq_format = 'JSONEachRow', rabbitmq_row_delimiter = '\\n'; CREATE TABLE test.view (key UInt64, value UInt64, channel_id String) ENGINE = MergeTree ORDER BY key SETTINGS old_parts_lifetime=5, cleanup_delay_period=2, cleanup_delay_period_random_add=3, cleanup_thread_preferred_points_per_iteration=0; CREATE MATERIALIZED VIEW test.consumer TO test.view AS SELECT *, _channel_id AS channel_id FROM test.rabbitmq; """ ) i = [0] messages_num = 10000 credentials = pika.PlainCredentials("root", "clickhouse") parameters = pika.ConnectionParameters( rabbitmq_cluster.rabbitmq_ip, rabbitmq_cluster.rabbitmq_port, "/", credentials ) def produce(): connection = pika.BlockingConnection(parameters) channel = connection.channel() messages = [] for _ in range(messages_num): messages.append(json.dumps({"key": i[0], "value": i[0]})) i[0] += 1 current = 0 for message in messages: current += 1 mes_id = str(current) channel.basic_publish( exchange="test_sharding", routing_key="", properties=pika.BasicProperties(message_id=mes_id), body=message, ) connection.close() threads = [] threads_num = 10 for _ in range(threads_num): threads.append(threading.Thread(target=produce)) for thread in threads: time.sleep(random.uniform(0, 1)) thread.start() result1 = "" deadline = time.monotonic() + DEFAULT_TIMEOUT_SEC expected = messages_num * threads_num while time.monotonic() < deadline: result1 = instance.query("SELECT count() FROM test.view") time.sleep(1) if int(result1) == expected: break logging.debug(f"Result {result1} / {expected}") else: > pytest.fail( f"Time limit of {DEFAULT_TIMEOUT_SEC} seconds reached. The result did not match the expected value." ) E Failed: Time limit of 60 seconds reached. The result did not match the expected value. test_storage_rabbitmq/test.py:756: Failed ------------------------------ Captured log setup ------------------------------ 2025-04-02 17:00:55 [ 645 ] DEBUG : RabbitMQ is available - running test (test.py:113, rabbitmq_setup_teardown) ------------------------------ Captured log call ------------------------------- 2025-04-02 17:00:55 [ 645 ] DEBUG : Executing query CREATE TABLE test.rabbitmq (key UInt64, value UInt64) ENGINE = RabbitMQ SETTINGS rabbitmq_host_port = 'rabbitmq1:5672', rabbitmq_exchange_name = 'test_sharding', rabbitmq_num_queues = 5, rabbitmq_num_consumers = 10, rabbitmq_max_block_size = 100, rabbitmq_flush_interval_ms=500, rabbitmq_format = 'JSONEachRow', rabbitmq_row_delimiter = '\n'; CREATE TABLE test.view (key UInt64, value UInt64, channel_id String) ENGINE = MergeTree ORDER BY key SETTINGS old_parts_lifetime=5, cleanup_delay_period=2, cleanup_delay_period_random_add=3, cleanup_thread_preferred_points_per_iteration=0; CREATE MATERIALIZED VIEW test.consumer TO test.view AS SELECT *, _channel_id AS channel_id FROM test.rabbitmq; on instance (cluster.py:3677, query) 2025-04-02 17:01:02 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:04 [ 645 ] DEBUG : Result 11484 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:04 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:05 [ 645 ] DEBUG : Result 12675 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:05 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:07 [ 645 ] DEBUG : Result 14609 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:07 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:08 [ 645 ] DEBUG : Result 15806 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:08 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:09 [ 645 ] DEBUG : Result 16243 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:09 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:11 [ 645 ] DEBUG : Result 16453 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:11 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:12 [ 645 ] DEBUG : Result 18453 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:12 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:13 [ 645 ] DEBUG : Result 18892 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:13 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:15 [ 645 ] DEBUG : Result 19512 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:15 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:16 [ 645 ] DEBUG : Result 19732 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:16 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:17 [ 645 ] DEBUG : Result 20142 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:17 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:19 [ 645 ] DEBUG : Result 20374 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:19 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:20 [ 645 ] DEBUG : Result 22165 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:20 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:21 [ 645 ] DEBUG : Result 23083 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:21 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:23 [ 645 ] DEBUG : Result 24291 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:23 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:24 [ 645 ] DEBUG : Result 25657 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:24 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:26 [ 645 ] DEBUG : Result 26462 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:26 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:27 [ 645 ] DEBUG : Result 26819 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:27 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:28 [ 645 ] DEBUG : Result 28788 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:28 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:30 [ 645 ] DEBUG : Result 30486 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:30 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:31 [ 645 ] DEBUG : Result 30799 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:31 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:32 [ 645 ] DEBUG : Result 31322 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:32 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:34 [ 645 ] DEBUG : Result 32607 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:34 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:35 [ 645 ] DEBUG : Result 33282 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:35 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:36 [ 645 ] DEBUG : Result 35388 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:36 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:38 [ 645 ] DEBUG : Result 36254 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:38 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:39 [ 645 ] DEBUG : Result 36469 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:39 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:40 [ 645 ] DEBUG : Result 38034 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:40 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:42 [ 645 ] DEBUG : Result 38287 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:42 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:43 [ 645 ] DEBUG : Result 38893 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:43 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:44 [ 645 ] DEBUG : Result 40893 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:44 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:46 [ 645 ] DEBUG : Result 43018 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:46 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:47 [ 645 ] DEBUG : Result 43618 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:47 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:48 [ 645 ] DEBUG : Result 43832 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:48 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:50 [ 645 ] DEBUG : Result 44331 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:50 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:51 [ 645 ] DEBUG : Result 44765 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:51 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:52 [ 645 ] DEBUG : Result 47414 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:52 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:54 [ 645 ] DEBUG : Result 54702 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:54 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:55 [ 645 ] DEBUG : Result 68202 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:55 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:56 [ 645 ] DEBUG : Result 76351 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:56 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:57 [ 645 ] DEBUG : Result 83610 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:57 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:01:59 [ 645 ] DEBUG : Result 89542 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:01:59 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:02:00 [ 645 ] DEBUG : Result 93056 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:02:00 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:02:01 [ 645 ] DEBUG : Result 98471 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) 2025-04-02 17:02:01 [ 645 ] DEBUG : Executing query SELECT count() FROM test.view on instance (cluster.py:3677, query) 2025-04-02 17:02:03 [ 645 ] DEBUG : Result 99928 / 100000 (test.py:754, test_rabbitmq_sharding_between_queues_publish) ---------------------------- Captured log teardown ----------------------------- 2025-04-02 17:02:03 [ 645 ] DEBUG : Executing query DROP DATABASE test SYNC on instance (cluster.py:3677, query) 2025-04-02 17:02:03 [ 645 ] DEBUG : Executing query CREATE DATABASE test on instance (cluster.py:3677, query) =============================== warnings summary =============================== test_throttling/test.py::test_backup_throttling[no_local_throttling] /usr/local/lib/python3.10/dist-packages/urllib3/connectionpool.py:1100: InsecureRequestWarning: Unverified HTTPS request is being made to host '172.16.1.4'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#tls-warnings warnings.warn( -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html ============================== slowest durations =============================== 111.55s call test_storage_rabbitmq/test.py::test_rabbitmq_random_detach 101.04s call test_storage_rabbitmq/test.py::test_rabbitmq_mv_combo 71.16s call test_storage_rabbitmq/test.py::test_row_based_formats 67.98s call test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish 62.86s call test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 61.20s call test_storage_rabbitmq/test.py::test_rabbitmq_multiple_bindings 60.51s call test_storage_rabbitmq/test.py::test_rabbitmq_many_consumers_to_each_queue 38.41s call test_storage_rabbitmq/test.py::test_rabbitmq_overloaded_insert 36.75s call test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 31.62s teardown test_throttling/test.py::test_write_throttling[user_remote_throttling] 28.37s call test_storage_rabbitmq/test.py::test_rabbitmq_many_inserts 24.67s setup test_table_function_redis/test.py::test_create_table 24.18s call test_throttling/test.py::test_backup_throttling_override 22.32s setup test_storage_rabbitmq/test.py::test_rabbitmq_insert_headers_exchange 20.66s call test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange 20.65s call test_storage_rabbitmq/test.py::test_rabbitmq_select[1] 19.62s call test_storage_rabbitmq/test.py::test_rabbitmq_select[0] 19.14s call test_throttling/test.py::test_read_throttling[user_local_throttling] 17.27s call test_throttling/test.py::test_write_throttling[user_remote_throttling] 17.19s call test_throttling/test.py::test_read_throttling[user_remote_throttling] 16.69s setup test_system_queries/test.py::test_DROP_DNS_CACHE 16.14s setup test_throttling/test.py::test_backup_throttling[no_local_throttling] 15.99s call test_throttling/test.py::test_write_throttling[local_user_throttling] 15.55s call test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling] 15.50s call test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling] 14.73s call test_throttling/test.py::test_backup_throttling[user_local_throttling] 13.67s setup test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_with_interserver_listen_host 13.30s call test_storage_rabbitmq/test.py::test_rabbitmq_predefined_configuration 13.19s call test_throttling/test.py::test_read_throttling[server_local_throttling] 12.63s call test_throttling/test.py::test_read_throttling[server_remote_throttling] 12.58s call test_throttling/test.py::test_write_throttling[server_remote_throttling] 11.78s call test_throttling/test.py::test_backup_throttling[server_local_throttling] 11.73s call test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling] 11.72s call test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling] 11.67s call test_throttling/test.py::test_write_throttling[local_server_throttling] 10.80s call test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_2 10.27s call test_storage_rabbitmq/test.py::test_rabbitmq_nack_failed_insert 10.03s call test_storage_rabbitmq/test.py::test_rabbitmq_queue_consume 9.70s teardown test_throttling/test.py::test_write_throttling[local_server_throttling] 9.63s teardown test_throttling/test.py::test_write_throttling[local_user_throttling] 9.63s teardown test_throttling/test.py::test_read_throttling[user_local_throttling] 9.57s teardown test_throttling/test.py::test_write_throttling[no_remote_throttling] 9.50s call test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling] 9.35s teardown test_throttling/test.py::test_backup_throttling_override 9.33s call test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages 9.17s teardown test_throttling/test.py::test_write_throttling[server_remote_throttling] 9.01s teardown test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling] 8.93s teardown test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling] 8.91s teardown test_throttling/test.py::test_read_throttling[no_local_throttling] 8.88s teardown test_throttling/test.py::test_read_throttling[server_remote_throttling] 8.86s teardown test_throttling/test.py::test_read_throttling[user_remote_throttling] 8.85s teardown test_throttling/test.py::test_read_throttling[server_local_throttling] 8.46s teardown test_throttling/test.py::test_write_throttling[no_local_throttling] 8.26s teardown test_throttling/test.py::test_read_throttling[no_remote_throttling] 8.21s teardown test_throttling/test.py::test_max_merges_bandwidth_for_server 8.20s teardown test_throttling/test.py::test_backup_throttling[server_local_throttling] 8.15s teardown test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling] 8.01s call test_system_queries/test.py::test_system_flush_logs 7.99s teardown test_storage_rabbitmq/test.py::test_row_based_formats 7.88s call test_storage_rabbitmq/test.py::test_rabbitmq_produce_consume_avro 7.88s call test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling] 7.87s call test_throttling/test.py::test_max_mutations_bandwidth_for_server 7.83s call test_throttling/test.py::test_max_merges_bandwidth_for_server 7.30s call test_storage_rabbitmq/test.py::test_rabbitmq_queue_settings 7.19s teardown test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling] 7.16s teardown test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling] 7.16s teardown test_throttling/test.py::test_max_mutations_bandwidth_for_server 7.10s teardown test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling] 7.10s teardown test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling] 7.09s teardown test_throttling/test.py::test_backup_throttling[user_local_throttling] 7.06s teardown test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling] 6.43s teardown test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling] 6.37s teardown test_throttling/test.py::test_backup_throttling[no_local_throttling] 6.34s call test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_1 5.14s teardown test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_without_interserver_listen_host 4.76s call test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view 4.63s call test_storage_rabbitmq/test.py::test_rabbitmq_msgpack 4.42s teardown test_system_queries/test.py::test_system_flush_logs 4.30s call test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns 4.07s teardown test_table_function_redis/test.py::test_simple_select 3.88s call test_system_queries/test.py::test_DROP_DNS_CACHE 3.80s call test_storage_rabbitmq/test.py::test_rabbitmq_many_materialized_views 3.45s call test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY 3.26s call test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view 3.19s call test_storage_rabbitmq/test.py::test_rabbitmq_json_without_delimiter 3.02s call test_storage_rabbitmq/test.py::test_rabbitmq_insert_headers_exchange 2.82s call test_storage_rabbitmq/test.py::test_rabbitmq_macros 2.82s call test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view_with_subquery 2.82s call test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter 1.76s call test_storage_rabbitmq/test.py::test_rabbitmq_issue_30691 1.75s call test_storage_rabbitmq/test.py::test_rabbitmq_vhost 1.74s call test_storage_rabbitmq/test.py::test_rabbitmq_select_empty 0.92s call test_table_function_redis/test.py::test_data_type 0.91s call test_table_function_redis/test.py::test_create_table 0.89s call test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling] 0.83s call test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling] 0.83s call test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling] 0.74s call test_throttling/test.py::test_read_throttling[no_remote_throttling] 0.73s call test_throttling/test.py::test_backup_throttling[no_local_throttling] 0.73s teardown test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 0.73s teardown test_storage_rabbitmq/test.py::test_rabbitmq_random_detach 0.68s call test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS 0.66s teardown test_storage_rabbitmq/test.py::test_rabbitmq_multiple_bindings 0.65s teardown test_storage_rabbitmq/test.py::test_rabbitmq_many_consumers_to_each_queue 0.64s call test_throttling/test.py::test_read_throttling[no_local_throttling] 0.64s call test_throttling/test.py::test_write_throttling[no_remote_throttling] 0.59s call test_throttling/test.py::test_write_throttling[no_local_throttling] 0.58s teardown test_storage_rabbitmq/test.py::test_rabbitmq_predefined_configuration 0.58s teardown test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 0.58s teardown test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish 0.54s call test_table_function_redis/test.py::test_simple_select 0.54s teardown test_storage_rabbitmq/test.py::test_rabbitmq_issue_30691 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_insert_headers_exchange 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view_with_subquery 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_many_materialized_views 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_overloaded_insert 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_select_empty 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_select[0] 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_1 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_macros 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_nack_failed_insert 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_queue_consume 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_many_inserts 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_queue_settings 0.53s teardown test_storage_rabbitmq/test.py::test_rabbitmq_json_without_delimiter 0.48s teardown test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange 0.48s teardown test_storage_rabbitmq/test.py::test_rabbitmq_msgpack 0.48s teardown test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_2 0.48s teardown test_storage_rabbitmq/test.py::test_rabbitmq_vhost 0.48s teardown test_storage_rabbitmq/test.py::test_rabbitmq_select[1] 0.48s teardown test_storage_rabbitmq/test.py::test_rabbitmq_mv_combo 0.48s teardown test_storage_rabbitmq/test.py::test_rabbitmq_produce_consume_avro 0.01s call test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_with_interserver_listen_host 0.00s call test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_without_interserver_listen_host 0.00s setup test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[user_local_throttling] 0.00s setup test_throttling/test.py::test_write_throttling[server_remote_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling] 0.00s setup test_throttling/test.py::test_write_throttling[no_local_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[server_local_throttling] 0.00s setup test_throttling/test.py::test_write_throttling[no_remote_throttling] 0.00s setup test_throttling/test.py::test_write_throttling[user_remote_throttling] 0.00s setup test_throttling/test.py::test_read_throttling[user_local_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling] 0.00s setup test_storage_rabbitmq/test.py::test_row_based_formats 0.00s setup test_throttling/test.py::test_read_throttling[user_remote_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling] 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns 0.00s setup test_throttling/test.py::test_write_throttling[local_user_throttling] 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_json_without_delimiter 0.00s setup test_throttling/test.py::test_write_throttling[local_server_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling] 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_select[0] 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view_with_subquery 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages 0.00s setup test_throttling/test.py::test_backup_throttling_override 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_issue_30691 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_many_inserts 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_vhost 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_1 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_select[1] 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_random_detach 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_many_consumers_to_each_queue 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_many_materialized_views 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_macros 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_multiple_bindings 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_select_empty 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_2 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_msgpack 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_overloaded_insert 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_queue_settings 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter 0.00s setup test_throttling/test.py::test_read_throttling[no_remote_throttling] 0.00s setup test_throttling/test.py::test_read_throttling[server_local_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling] 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_mv_combo 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_queue_consume 0.00s setup test_system_queries/test.py::test_system_flush_logs 0.00s setup test_table_function_redis/test.py::test_data_type 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_produce_consume_avro 0.00s setup test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_predefined_configuration 0.00s setup test_table_function_redis/test.py::test_simple_select 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_nack_failed_insert 0.00s setup test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_without_interserver_listen_host 0.00s setup test_throttling/test.py::test_read_throttling[no_local_throttling] 0.00s setup test_throttling/test.py::test_read_throttling[server_remote_throttling] 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 0.00s teardown test_table_function_redis/test.py::test_create_table 0.00s setup test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling] 0.00s teardown test_system_queries/test.py::test_DROP_DNS_CACHE 0.00s teardown test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_with_interserver_listen_host 0.00s teardown test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY 0.00s setup test_throttling/test.py::test_max_mutations_bandwidth_for_server 0.00s teardown test_table_function_redis/test.py::test_data_type 0.00s setup test_throttling/test.py::test_max_merges_bandwidth_for_server 0.00s setup test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY 0.00s teardown test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS =========================== short test summary info ============================ FAILED test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish PASSED test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_with_interserver_listen_host PASSED test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_without_interserver_listen_host PASSED test_throttling/test.py::test_backup_throttling[no_local_throttling] PASSED test_system_queries/test.py::test_DROP_DNS_CACHE PASSED test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS PASSED test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling] PASSED test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY PASSED test_storage_rabbitmq/test.py::test_rabbitmq_insert_headers_exchange PASSED test_table_function_redis/test.py::test_create_table PASSED test_table_function_redis/test.py::test_data_type PASSED test_table_function_redis/test.py::test_simple_select PASSED test_storage_rabbitmq/test.py::test_rabbitmq_issue_30691 PASSED test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_json_without_delimiter PASSED test_system_queries/test.py::test_system_flush_logs PASSED test_storage_rabbitmq/test.py::test_rabbitmq_macros PASSED test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling] PASSED test_throttling/test.py::test_backup_throttling[server_local_throttling] PASSED test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_many_consumers_to_each_queue PASSED test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling] PASSED test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_many_inserts PASSED test_storage_rabbitmq/test.py::test_rabbitmq_many_materialized_views PASSED test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view PASSED test_throttling/test.py::test_backup_throttling[user_local_throttling] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view_with_subquery PASSED test_storage_rabbitmq/test.py::test_rabbitmq_msgpack PASSED test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling] PASSED test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling] PASSED test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_multiple_bindings PASSED test_throttling/test.py::test_backup_throttling_override PASSED test_throttling/test.py::test_max_merges_bandwidth_for_server PASSED test_throttling/test.py::test_max_mutations_bandwidth_for_server PASSED test_throttling/test.py::test_read_throttling[no_local_throttling] PASSED test_throttling/test.py::test_read_throttling[no_remote_throttling] PASSED test_throttling/test.py::test_read_throttling[server_local_throttling] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_mv_combo PASSED test_storage_rabbitmq/test.py::test_rabbitmq_nack_failed_insert PASSED test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_1 PASSED test_throttling/test.py::test_read_throttling[server_remote_throttling] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_2 PASSED test_throttling/test.py::test_read_throttling[user_local_throttling] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_overloaded_insert PASSED test_throttling/test.py::test_read_throttling[user_remote_throttling] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_predefined_configuration PASSED test_storage_rabbitmq/test.py::test_rabbitmq_produce_consume_avro PASSED test_throttling/test.py::test_write_throttling[local_server_throttling] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_queue_consume PASSED test_storage_rabbitmq/test.py::test_rabbitmq_queue_settings PASSED test_throttling/test.py::test_write_throttling[local_user_throttling] PASSED test_throttling/test.py::test_write_throttling[no_local_throttling] PASSED test_throttling/test.py::test_write_throttling[no_remote_throttling] PASSED test_throttling/test.py::test_write_throttling[server_remote_throttling] PASSED test_throttling/test.py::test_write_throttling[user_remote_throttling] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_random_detach PASSED test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages PASSED test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 PASSED test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select[0] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select[1] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select_empty PASSED test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange PASSED test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter PASSED test_storage_rabbitmq/test.py::test_rabbitmq_vhost PASSED test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns PASSED test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view PASSED test_storage_rabbitmq/test.py::test_row_based_formats ============= 1 failed, 69 passed, 1 warning in 867.94s (0:14:27) ============== Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration/./runner", line 528, in subprocess.check_call(cmd, shell=True) File "/usr/lib/python3.10/subprocess.py", line 369, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'docker run --rm --name clickhouse_integration_tests_86ijid --privileged --dns-search='.' --memory=30709035008 --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=5dc43a6382f0 -e DOCKER_BASE_TAG=6712d5cc610d -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=caad4729259e -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e CLICKHOUSE_USE_OLD_ANALYZER=1 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_storage_rabbitmq/test.py::test_rabbitmq_insert_headers_exchange test_storage_rabbitmq/test.py::test_rabbitmq_issue_30691 test_storage_rabbitmq/test.py::test_rabbitmq_json_without_delimiter test_storage_rabbitmq/test.py::test_rabbitmq_macros test_storage_rabbitmq/test.py::test_rabbitmq_many_consumers_to_each_queue test_storage_rabbitmq/test.py::test_rabbitmq_many_inserts test_storage_rabbitmq/test.py::test_rabbitmq_many_materialized_views test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view test_storage_rabbitmq/test.py::test_rabbitmq_materialized_view_with_subquery test_storage_rabbitmq/test.py::test_rabbitmq_msgpack test_storage_rabbitmq/test.py::test_rabbitmq_multiple_bindings test_storage_rabbitmq/test.py::test_rabbitmq_mv_combo test_storage_rabbitmq/test.py::test_rabbitmq_nack_failed_insert test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_1 test_storage_rabbitmq/test.py::test_rabbitmq_no_connection_at_startup_2 test_storage_rabbitmq/test.py::test_rabbitmq_overloaded_insert test_storage_rabbitmq/test.py::test_rabbitmq_predefined_configuration test_storage_rabbitmq/test.py::test_rabbitmq_produce_consume_avro test_storage_rabbitmq/test.py::test_rabbitmq_queue_consume test_storage_rabbitmq/test.py::test_rabbitmq_queue_settings test_storage_rabbitmq/test.py::test_rabbitmq_random_detach test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 'test_storage_rabbitmq/test.py::test_rabbitmq_select[0]' 'test_storage_rabbitmq/test.py::test_rabbitmq_select[1]' test_storage_rabbitmq/test.py::test_rabbitmq_select_empty test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter test_storage_rabbitmq/test.py::test_rabbitmq_vhost test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view test_storage_rabbitmq/test.py::test_row_based_formats test_system_queries/test.py::test_DROP_DNS_CACHE test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY test_system_queries/test.py::test_system_flush_logs test_table_function_redis/test.py::test_create_table test_table_function_redis/test.py::test_data_type test_table_function_redis/test.py::test_simple_select test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_with_interserver_listen_host test_tcp_handler_interserver_listen_host/test_case.py::test_request_to_node_without_interserver_listen_host 'test_throttling/test.py::test_backup_throttling[no_local_throttling]' 'test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling]' 'test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[server_local_throttling]' 'test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling]' 'test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[user_local_throttling]' 'test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling]' 'test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling]' test_throttling/test.py::test_backup_throttling_override test_throttling/test.py::test_max_merges_bandwidth_for_server test_throttling/test.py::test_max_mutations_bandwidth_for_server 'test_throttling/test.py::test_read_throttling[no_local_throttling]' 'test_throttling/test.py::test_read_throttling[no_remote_throttling]' 'test_throttling/test.py::test_read_throttling[server_local_throttling]' 'test_throttling/test.py::test_read_throttling[server_remote_throttling]' 'test_throttling/test.py::test_read_throttling[user_local_throttling]' 'test_throttling/test.py::test_read_throttling[user_remote_throttling]' 'test_throttling/test.py::test_write_throttling[local_server_throttling]' 'test_throttling/test.py::test_write_throttling[local_user_throttling]' 'test_throttling/test.py::test_write_throttling[no_local_throttling]' 'test_throttling/test.py::test_write_throttling[no_remote_throttling]' 'test_throttling/test.py::test_write_throttling[server_remote_throttling]' 'test_throttling/test.py::test_write_throttling[user_remote_throttling]' -vvv" altinityinfra/integration-tests-runner:cd6390247eca ' returned non-zero exit status 1.